﻿CREATE TABLE [CFL].[Config]
(
	[Name] VARCHAR(100) NOT NULL, 
    [Description] VARCHAR(200) NULL , 
    [Value] VARCHAR(MAX) NULL, 
    CONSTRAINT [PK_Config] PRIMARY KEY ([Name]),
	CONSTRAINT [UK_CFL.Config_Name] UNIQUE NONCLUSTERED ([Name]),
)

GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'The name of the config variable',
    @level0type = N'SCHEMA',
    @level0name = N'CFL',
    @level1type = N'TABLE',
    @level1name = N'Config',
    @level2type = N'COLUMN',
    @level2name = N'Name'